/* for NBJ testing.  */

!ls
create table soaps(soapid  i, sname  c28, network  c4, rating  f);
create table stars(starid  i, stname  c20, plays  c12, soapid  i);

/* load tuples from ./tests/stars.data */
load soaps("../soaps.data");

load stars("../stars.data");

queryplans on;
select * from soaps;
exit;
select * from stars, soaps where stars.soapid = soaps.soapid;

exit;
